package com.etl.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.Date;

/**
 * Description: 抽取任务表
 *
 * @author fengxiaoyang
 * @date 2021年12月4日 下午5:28:50
 */
@Data
@Accessors(chain = true)
@ApiModel("抽取增量任务表")
@TableName("etl_task_increment")
public class EtlTaskIncrement implements Serializable {

  	@ApiModelProperty(value = "主键ID" )
	@TableId(type = IdType.AUTO)
	private Long kid;

  	@ApiModelProperty(value = "批次号" )
	private Integer batch;

	@ApiModelProperty(value = "批次名称" )
	private String batchName;

	@ApiModelProperty(value = "来源i数据库d" )
	private Integer sourceDbId;

  	@ApiModelProperty(value = "数据来源" )
	private String sourceDbSysname;

  	@ApiModelProperty(value = "数据来源表名" )
	private String sourceTableName;



  	@ApiModelProperty(value = "目标库id" )
	private Integer targetDbId;

  	@ApiModelProperty(value = "目标库名称" )
	private String targetDbSysname;

  	@ApiModelProperty(value = "目标库表名" )
	private String targetTableName;

	@ApiModelProperty(value = "数据来源表名" )
	private String targetTablePrimaryId;


  	@ApiModelProperty(value = "执行状态，0等待执行；1任务运行中；2运行错误；3执行成功；" )
	private Integer execFlag;

  	@ApiModelProperty(value = "表注释" )
	private String tableComment;

  	@ApiModelProperty(value = "数据提取SQL" )
	private String sql1;

  	@ApiModelProperty(value = "sql执行脚本1" )
	private String sql2;

  	@ApiModelProperty(value = "sql执行脚本" )
	private String sql3;

  	@ApiModelProperty(value = "sql执行脚本" )
	private String sql4;

  	@ApiModelProperty(value = "是否启用数据提取；0禁用，1启用" )
	private Integer flag;

  	@ApiModelProperty(value = "每次提交数据量" )
	private Integer commitSize;

	@ApiModelProperty(value = "创建账户" )
	private String createAccount;

	@ApiModelProperty(value = "数据最后抽取时间" )
	private Date dataLastExtractTime;

  	@ApiModelProperty(value = "创建时间" )
	private Date createTime;

  	@ApiModelProperty(value = "数据更新时间" )
	private Date updateTime;

  	@ApiModelProperty(value = "数据开始抽取时间" )
	private Date beginTime;

  	@ApiModelProperty(value = "数据最后更新时间" )
	private Date lastTime;


}
